UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 't6XgbrEM6n4QplUt5KPb/ay5AyeaSTAFJaYTrV2C7yQ=' 
WHERE 
  key_id = '172526ba32177e45d4e2149679e1fc39d8e33a0cc5a3ceb7f8016ea043eebda2' 
  AND (
    token = 't6XgbrEM6n4QplUt5KPb/ay5AyeaSTAFJaYTrV2C7yQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031