UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CnXdFIwFSguYB0vaC2h93MLvcrcSyht2fE5QUKWq+0U='
WHERE
key_id = '8d0195d8556ad470aa19a8be61e05fcce0f66b99cf4064eecdea3830f7cf5b12'
AND (
token = 'CnXdFIwFSguYB0vaC2h93MLvcrcSyht2fE5QUKWq+0U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)