UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bbY9VoMjwpOHRseibJE8F++hhAbu7ZvRDkYcoRyeS70='
WHERE
key_id = 'c8b9a6e2a985dd172e0e3c679681c958f23049d0cc12e45ad9bbe8bb606026a0'
AND (
token = 'bbY9VoMjwpOHRseibJE8F++hhAbu7ZvRDkYcoRyeS70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)