UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ILxYc38UEAU7KLt1EarY6R4U9dgRpi4row6wPOPrgCU='
WHERE
key_id = '687ae9ce1226236efd5e8f6bbce49488847df5967e4c5f1edb02871154839a9a'
AND (
token = 'ILxYc38UEAU7KLt1EarY6R4U9dgRpi4row6wPOPrgCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)