UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '78jwoCfu2ErvXWo8w9layLs1ar6ULtYq38MMB9M1fkI='
WHERE
key_id = 'd7957d9d89ee7297cb49d72f68410b79321946064a97cf8d88fd3d40d905a927'
AND (
token = '78jwoCfu2ErvXWo8w9layLs1ar6ULtYq38MMB9M1fkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)