UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TOki0KYdb9LC+RrcCNqx8QdFfKzkog1cm2NPrXuYI8Y='
WHERE
key_id = 'a1ff3e2f046416165e552e85be1301103701a1edc1b410b1670a23cc7f255907'
AND (
token = 'TOki0KYdb9LC+RrcCNqx8QdFfKzkog1cm2NPrXuYI8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)