UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZZSn3c+NyWLw8hDmDkej3WqrpJTwPNvUL+tBiQZbhXI='
WHERE
key_id = '8c8a60c6808e75c1801df2df5344a7caf8193c72ed576596bd7d651592179be3'
AND (
token = 'ZZSn3c+NyWLw8hDmDkej3WqrpJTwPNvUL+tBiQZbhXI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)