UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'soyuZCJyNrY6WWothuK0/37ao6H74m7116XT5dPWIX0='
WHERE
key_id = '6c843c47ae924299cf3b5e7ce25b72b9b32d5e212757a0ecb592c1b3ebfa637a'
AND (
token = 'soyuZCJyNrY6WWothuK0/37ao6H74m7116XT5dPWIX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)