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