UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DvPpXsT0LbfIxT3Rlr4hV9DYW5eMxk33NnCq20a54LA='
WHERE
key_id = 'fbf8b0df3651f0232ca5f97ffc8b24b92d811bcc97f6a15cd11ac65c4b002139'
AND (
token = 'DvPpXsT0LbfIxT3Rlr4hV9DYW5eMxk33NnCq20a54LA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)