UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5K8/PeqvbN9GzrnjiB9I9u3mlapWwxfnwxxrDWIBODw='
WHERE
key_id = '7a452669037dd93127b52a7f22ea72bb3470faa369d57f26774fd8f011f56a3a'
AND (
token = '5K8/PeqvbN9GzrnjiB9I9u3mlapWwxfnwxxrDWIBODw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)