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

Query time 0.00018