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