UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IygQJxb08/VyTG49dIPwaPDAWBnQB/kF9ZuJ9jr5XHw=' 
WHERE 
  key_id = '18532bf1efa6503805283e0968584f24854b1ab407f3699e6c879c89e687665f' 
  AND (
    token = 'IygQJxb08/VyTG49dIPwaPDAWBnQB/kF9ZuJ9jr5XHw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025