UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5+iTFdNYe1yC0igrgNi3jh4lq25xvz+I9xQdxQdG1/I=' 
WHERE 
  key_id = 'c5f9379d98520832755a42c3faa6fdd240e0c5b0ac2bdbb77cd87bf610f74df6' 
  AND (
    token = '5+iTFdNYe1yC0igrgNi3jh4lq25xvz+I9xQdxQdG1/I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020