UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mGKjgYCDT8Waa85StDRsYjfyBkmJAdyKLnPYt/QXJPU='
WHERE
key_id = '47a5a247aa4b152f8470319b2349fb9f2d116048610166a722e95b37be9eb011'
AND (
token = 'mGKjgYCDT8Waa85StDRsYjfyBkmJAdyKLnPYt/QXJPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)