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