UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q5inGxZqXvWRlDgUmrSNcxtmUkb0pKXT8HPkhbg39Tw='
WHERE
key_id = '1f2f9517f3909490e0c0eebb55df60457d5985e7a40ece224a3082ac32ace8ae'
AND (
token = 'Q5inGxZqXvWRlDgUmrSNcxtmUkb0pKXT8HPkhbg39Tw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)