UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q47EAb8xzD53X3PF1L6NqhwwzqWjRJZfhc0tW5+mFZo='
WHERE
key_id = 'be0d5e135f72817911c58ba0867cc5f97e899e9da3ea85c1c2fec6a982a08448'
AND (
token = 'q47EAb8xzD53X3PF1L6NqhwwzqWjRJZfhc0tW5+mFZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)