UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'twn1/m0L1dXeP3Nfi4132JsN6SPKfgcu7e7kJ5bZGWM=' 
WHERE 
  key_id = '37ac7b4f44d21cfc2a58cb1965d7fdc08c6df39dfef4bbb35bb927af972142f7' 
  AND (
    token = 'twn1/m0L1dXeP3Nfi4132JsN6SPKfgcu7e7kJ5bZGWM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032