UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '3zsZb6LQVlqajgUgRsonnGG8IOMZVDqFv2VUx6YmLoo=' 
WHERE 
  key_id = 'fa33f01d1c585faff33860d08b1a2af1eea55a2d039a6e0110942322acd6b75d' 
  AND (
    token = '3zsZb6LQVlqajgUgRsonnGG8IOMZVDqFv2VUx6YmLoo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022