UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xx4JNMuoHiY7H1wsEuk8qXM9rNtowjGxKNP1PlnqZ9U='
WHERE
key_id = 'b7626c03e05d4cf5f9e79836717c3a3da73f215e217a49d28392039198d97b70'
AND (
token = 'Xx4JNMuoHiY7H1wsEuk8qXM9rNtowjGxKNP1PlnqZ9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)