UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IOAH3y+eqcsDOxPTNmD9tYeXPD1MA38wgTcFnCT2Jjg=' 
WHERE 
  key_id = '28b302b97d5c4a53c09a272c25f66dcb9efbb93d4fafbaf59c9ff9474bf4a5f5' 
  AND (
    token = 'IOAH3y+eqcsDOxPTNmD9tYeXPD1MA38wgTcFnCT2Jjg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021