UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Co+fBxRl8JDg0Tno3TnjU0i2sMD2U4vS9rwp3PBumV4=' 
WHERE 
  key_id = '445c49a4088e79d60f00526838c4118876fdc4634cdd4f1e26c507c19123bcee' 
  AND (
    token = 'Co+fBxRl8JDg0Tno3TnjU0i2sMD2U4vS9rwp3PBumV4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024