UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AhA6TpzANg20KSM3Me7nfFUVFt4VC1PzamO5sVkJGVs='
WHERE
key_id = '28797a7cdf7b20537d7f02ec4b406d486cbc541c0f984f085305cda92141d82c'
AND (
token = 'AhA6TpzANg20KSM3Me7nfFUVFt4VC1PzamO5sVkJGVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)