UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ZVnR20hd2P2+41ne8Fk7rHV0s9bcsSAfiL9hHHBJPyg=' 
WHERE 
  key_id = '534dcba8b9548806c1f5c8a4bdd327707cbc50f8aa6b1760c2d69a0231acf7dd' 
  AND (
    token = 'ZVnR20hd2P2+41ne8Fk7rHV0s9bcsSAfiL9hHHBJPyg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027