UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '6sWd+JzGS+2zvovLHPq4aN0ixTBf6S4+V3cOzYxPXdM=' 
WHERE 
  key_id = '5e8440fab7bbbdf0207155449221b11bcea5528cdb6f4b2eb5da3c7aaaee7f95' 
  AND (
    token = '6sWd+JzGS+2zvovLHPq4aN0ixTBf6S4+V3cOzYxPXdM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025