UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ra7UAKoPpPxIEz2WU/iWW9HBwJDP6fxCBG5F3jQ9xRk='
WHERE
key_id = 'fd4d78ea149d53ade791005d976645f37d389e6f435444336ce92100eabdc01e'
AND (
token = 'Ra7UAKoPpPxIEz2WU/iWW9HBwJDP6fxCBG5F3jQ9xRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)