UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XOjHIA8f+lh4KTe/pL1vjTxZ3V+BIXuXPc53jC7O5A4='
WHERE
key_id = 'ce85538dd926c3e09990accfc021566a5f1912510eea1b554cecc53df47df0f0'
AND (
token = 'XOjHIA8f+lh4KTe/pL1vjTxZ3V+BIXuXPc53jC7O5A4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)