UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S6cQSYeVTMWhP294Vc9EbGvZ1I6YIp6C5/wdFOdTsHo='
WHERE
key_id = 'be1ebc06335c6c22cb390fad414dadffb61c896a9cec0089414c82fb8a2ea4ee'
AND (
token = 'S6cQSYeVTMWhP294Vc9EbGvZ1I6YIp6C5/wdFOdTsHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)