UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hpLGdDIx0b+vlqO27b8JcV7fCFL+Nrnc+fweFDV8obU='
WHERE
key_id = 'b1f4f8ae33e21d8de0e8f076233f17d87704bce153062ffcd1db226bf40cf30a'
AND (
token = 'hpLGdDIx0b+vlqO27b8JcV7fCFL+Nrnc+fweFDV8obU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)