UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mr4zbWBz2ug7KJTiJ2s7R9dWghz5nL/Fu/WAE0HZNk4=' 
WHERE 
  key_id = '3ab6f7f2bac13c53c6a804a64a16190d8152ef9caa2798834c67cb06fc25335e' 
  AND (
    token = 'mr4zbWBz2ug7KJTiJ2s7R9dWghz5nL/Fu/WAE0HZNk4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028