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