UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Kto3/vbRH57WZuN/BfPW+YzEBrM0i73BkoFIY4/Ap68=' 
WHERE 
  key_id = '6e66727a35320cf78b66b094e24172b552ce939331fad45ed2fceefb18c33769' 
  AND (
    token = 'Kto3/vbRH57WZuN/BfPW+YzEBrM0i73BkoFIY4/Ap68=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024