UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'CPQ7N6ODjG+MGTCvFEJFcNYEytitufWlqGoWlspnlbE=' 
WHERE 
  key_id = '1e26f1383b01ea3af11d93075f5b830f462dfb7b5a40256ccf60648fa593e7eb' 
  AND (
    token = 'CPQ7N6ODjG+MGTCvFEJFcNYEytitufWlqGoWlspnlbE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032