UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5qi+Z46NgxyEGGvvy8f7KoNAtHIqKdJWlppXKt5PSPA='
WHERE
key_id = 'f0d182f79614918c6dfa7ecb6671cb84f43404a4743998954f8957b34bda8a74'
AND (
token = '5qi+Z46NgxyEGGvvy8f7KoNAtHIqKdJWlppXKt5PSPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)