UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'nWs+/qJK4mXx5JJj1/waqkMtLj+UXyhv0a4nUpOuVjg=' 
WHERE 
  key_id = '28235d289771e74e4b7cc9e6cbee9d50c4bcc7705f66a64f894dd4028e1ccfc9' 
  AND (
    token = 'nWs+/qJK4mXx5JJj1/waqkMtLj+UXyhv0a4nUpOuVjg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032