UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pTlM/ovDHI+97oruUNNhnXPPvr59M6P5woNPXRml0qU=' 
WHERE 
  key_id = 'a45538aac098992ee2b850f29471ef6ebf3d23e3c2b1557191cabb947bacb518' 
  AND (
    token = 'pTlM/ovDHI+97oruUNNhnXPPvr59M6P5woNPXRml0qU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023