UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8VaFrcwRdTHMTl8AAs1ymeExmFrYYB/WoLyKl5z3cW8='
WHERE
key_id = 'e9348e20f3df23201abfa68df8706caeb05c2fde150fc2d898878f18bbea15a6'
AND (
token = '8VaFrcwRdTHMTl8AAs1ymeExmFrYYB/WoLyKl5z3cW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)