UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GNAa4A2sLhNy+HpHc9eVgX6PBmtVdZNvZh49DRK05Os='
WHERE
key_id = 'c5e61babbc86c5ff6e9e59a09a45dbbc056237e189d5e9959210d81b4ab13a15'
AND (
token = 'GNAa4A2sLhNy+HpHc9eVgX6PBmtVdZNvZh49DRK05Os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)