UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6mKdrSfRUUw37wFv9f4L5AEg9aN6f9Iw4p4p/6yN72g='
WHERE
key_id = 'deebe93e45014046fa6865b3a768800891ddacfe2334e1b1de17612bdb334749'
AND (
token = '6mKdrSfRUUw37wFv9f4L5AEg9aN6f9Iw4p4p/6yN72g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)